from app import db
from datetime import datetime


class CustomerMessages(db.Model):
    __tablename__ = 'customer_messages'
    id = db.Column(db.Integer, primary_key=True)
    company_name = db.Column(db.String(255))
    company_address = db.Column(db.String(255))
    contact_name = db.Column(db.String(100))
    phone_number = db.Column(db.String(20))
    job_title = db.Column(db.String(100))
    email = db.Column(db.String(100))
    application_scenario = db.Column(db.Integer)
    requirement_description = db.Column(db.Text)
    create_time = db.Column(db.DATETIME, default=datetime.now)

